Pandas Profiling Report

Dataset statistics

Number of variables	27
Number of observations	10000
Missing cells	212
Missing cells (%)	0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	8.4 MiB
Average record size in memory	877.1 B

Variable types

NUM	12
CAT	10
BOOL	3
UNSUPPORTED	1
DATE	1

Reproduction

Analysis started	2020-05-23 15:35:04.011028
Analysis finished	2020-05-23 15:36:42.692804
Version	pandas-profiling v2.6.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

`moramaxima_12_meses_1` is highly correlated with `moramaxima_12_meses`	High Correlation
`moramaxima_12_meses` is highly correlated with `moramaxima_12_meses_1`	High Correlation
`sector` has 120 (1.2%) missing values	Missing
`ingresos` is highly skewed (γ1 = 40.05295954)	Skewed
`tiempactivano` is highly skewed (γ1 = 50.65164527)	Skewed
`calificacionsistema_financiero` is an unsupported type, check if it needs cleaning or further analysis	Rejected
`ingresos` has 255 (2.5%) zeros	Zeros
`personascargo` has 7507 (75.1%) zeros	Zeros
`tiempactivano` has 584 (5.8%) zeros	Zeros
`moramaxima_12_meses` has 4222 (42.2%) zeros	Zeros
`moramaxima_12_meses_1` has 4222 (42.2%) zeros	Zeros
`antiguedad_en_el_sistema_financiero` has 3368 (33.7%) zeros	Zeros
`numero_de_creditos_vigentes` has 8955 (89.5%) zeros	Zeros

cliente
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct count	10000
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5000.5
Minimum	1
Maximum	10000
Zeros	0
Zeros (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	500.95
Q1	2500.75
median	5000.5
Q3	7500.25
95-th percentile	9500.05
Maximum	10000
Range	9999
Interquartile range (IQR)	4999.5

Descriptive statistics

Standard deviation	2886.89568
Coefficient of variation (CV)	0.5773214038
Kurtosis	-1.2
Mean	5000.5
Median Absolute Deviation (MAD)	2500
Skewness	0
Sum	50005000
Variance	8334166.667

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[1.e+00 1.e+04], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2047	1	< 0.1%
5424	1	< 0.1%
1338	1	< 0.1%
7481	1	< 0.1%
5432	1	< 0.1%
9526	1	< 0.1%
3379	1	< 0.1%
1330	1	< 0.1%
7473	1	< 0.1%
9518	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
10000	1	< 0.1%
9999	1	< 0.1%
9998	1	< 0.1%
9997	1	< 0.1%
9996	1	< 0.1%

mora30
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

0	7641
1	2359

Frequency Table

Value	Count	Frequency (%)
0	7641	76.4%
1	2359	23.6%

mora60
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

0	8867
1	1133

Frequency Table

Value	Count	Frequency (%)
0	8867	88.7%
1	1133	11.3%

segmento
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

MDO	6838
STD	2389
VIP	484
MPY	157
PY	132

Value	Count	Frequency (%)
MDO	6838	68.4%
STD	2389	23.9%
VIP	484	4.8%
MPY	157	1.6%
PY	132	1.3%

Length

Max length	3
Mean length	2.9868
Min length	2

Value	Count	Frequency (%)
Uppercase_Letter	9	100.0%

Value	Count	Frequency (%)
Latin	9	100.0%

Value	Count	Frequency (%)
ASCII	9	100.0%

sector
Categorical

MISSING

Distinct count	10
Unique (%)	0.1%
Missing	120
Missing (%)	1.2%
Memory size	78.2 KiB

PERSONAS NATURALES	9467
COMERCIO	162
SERVICIOS	154
AGROPECUARIO	49
MANUFACTURA	34
Other values (5)	14

Value	Count	Frequency (%)
PERSONAS NATURALES	9467	94.7%
COMERCIO	162	1.6%
SERVICIOS	154	1.5%
AGROPECUARIO	49	0.5%
MANUFACTURA	34	0.3%
SERVICIOS FINANCIEROS	7	0.1%
EDIFICACIONES	4	< 0.1%
GOBIERNO	1	< 0.1%
RECURSOS NATURALES	1	< 0.1%
INFRAESTRUCTURA	1	< 0.1%
(Missing)	120	1.2%

Length

Max length	21
Mean length	17.465
Min length	3

Value	Count	Frequency (%)
Uppercase_Letter	18	85.7%
Lowercase_Letter	2	9.5%
Space_Separator	1	4.8%

Value	Count	Frequency (%)
Latin	20	95.2%
Common	1	4.8%

Value	Count	Frequency (%)
ASCII	21	100.0%

regcons
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

ESPECIAL	2952
OCCIDENTE	2750
CENTRO	1694
SUR	1494
NORTE	1110

Value	Count	Frequency (%)
ESPECIAL	2952	29.5%
OCCIDENTE	2750	27.5%
CENTRO	1694	16.9%
SUR	1494	14.9%
NORTE	1110	11.1%

Length

Max length	9
Mean length	6.8562
Min length	3

Value	Count	Frequency (%)
Uppercase_Letter	13	100.0%

Value	Count	Frequency (%)
Latin	13	100.0%

Value	Count	Frequency (%)
ASCII	13	100.0%

fdesem
Date

Distinct count	1029
Unique (%)	10.3%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Minimum	2011-03-02 00:00:00
Maximum	2016-02-29 00:00:00

Histogram

Histogram

ingresos
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct count	2906
Unique (%)	29.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.86068213
Minimum	0
Maximum	4527.398
Zeros	255
Zeros (%)	2.5%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.45
Q1	0.9201875
median	1.1684035
Q3	1.284
95-th percentile	1.388005
Maximum	4527.398
Range	4527.398
Interquartile range (IQR)	0.3638125

Descriptive statistics

Standard deviation	79.0319445
Coefficient of variation (CV)	16.25943487
Kurtosis	1831.176937
Mean	4.86068213
Median Absolute Deviation (MAD)	7.345154414
Skewness	40.05295954
Sum	48606.8213
Variance	6246.048252

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0.00000000e+00 5.00000000e-07 1.50000000e-06 1.55000000e-05 1.10000000e-02 ... 3.33903330e+01 5.53839580e+01 1.10161000e+02 5.18653653e+02 4.52739800e+03], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1.2	1239	12.4%
1.3	689	6.9%
1	516	5.2%
1.1	279	2.8%
0	255	2.5%
0.64435	242	2.4%
0.8	178	1.8%
0.9	174	1.7%
1.25	143	1.4%
0.616	136	1.4%
Other values (2896)	6149	61.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	255	2.5%
1e-06	92	0.9%
2e-06	1	< 0.1%
1e-05	1	< 0.1%
2.1e-05	1	< 0.1%

Value	Count	Frequency (%)
4527.398	1	< 0.1%
3079.894	3	< 0.1%
1961.198031	1	< 0.1%
1451.898583	3	< 0.1%
750	1	< 0.1%

personascargo
Real number (ℝ_≥0)

ZEROS

Distinct count	7
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.3769
Minimum	0
Maximum	6
Zeros	7507
Zeros (%)	75.1%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	6
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7621708998
Coefficient of variation (CV)	2.022209869
Kurtosis	6.595041672
Mean	0.3769
Median Absolute Deviation (MAD)	0.56587766
Skewness	2.399817814
Sum	3769
Variance	0.5809044804

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 4.5 6. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	7507	75.1%
1	1555	15.6%
2	692	6.9%
3	176	1.8%
4	50	0.5%
5	18	0.2%
6	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7507	75.1%
1	1555	15.6%
2	692	6.9%
3	176	1.8%
4	50	0.5%

Value	Count	Frequency (%)
6	2	< 0.1%
5	18	0.2%
4	50	0.5%
3	176	1.8%
2	692	6.9%

gastos
Real number (ℝ_≥0)

Distinct count	1228
Unique (%)	12.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.3890325201
Minimum	0.003214285714
Maximum	0.9
Zeros	0
Zeros (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0.003214285714
5-th percentile	0.308
Q1	0.308
median	0.374726
Q3	0.44975
95-th percentile	0.55
Maximum	0.9
Range	0.8967857143
Interquartile range (IQR)	0.14175

Descriptive statistics

Standard deviation	0.08429324901
Coefficient of variation (CV)	0.216674043
Kurtosis	1.128621063
Mean	0.3890325201
Median Absolute Deviation (MAD)	0.06913968457
Skewness	0.6516273447
Sum	3890.325201
Variance	0.007105351828

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0.00321429 0.16625 0.29982143 0.304 0.308032 ... 0.5779875 0.5975 0.600054 0.618 0.9 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0.308	2646	26.5%
0.4	632	6.3%
0.35	388	3.9%
0.5	360	3.6%
0.45	320	3.2%
0.375	188	1.9%
0.6	160	1.6%
0.425	158	1.6%
0.344	158	1.6%
0.55	118	1.2%
Other values (1218)	4872	48.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.003214285714	6	0.1%
0.03285714286	6	0.1%
0.0625	6	0.1%
0.09214285714	8	0.1%
0.12	2	< 0.1%

Value	Count	Frequency (%)
0.9	6	0.1%
0.8	2	< 0.1%
0.7	2	< 0.1%
0.68	2	< 0.1%
0.65	4	< 0.1%

tiempactivano
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct count	36
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	386.1667
Minimum	0
Maximum	1050000
Zeros	584
Zeros (%)	5.8%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	3
95-th percentile	9
Maximum	1050000
Range	1050000
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	19253.15957
Coefficient of variation (CV)	49.85712019
Kurtosis	2585.928623
Mean	386.1667
Median Absolute Deviation (MAD)	766.4430666
Skewness	50.65164527
Sum	3861667
Variance	370684153.6

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0.00e+00 5.00e-01 1.50e+00 2.50e+00 3.50e+00 ... 2.95e+01 3.05e+01 3.70e+01 5.70e+01 1.05e+06], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	4533	45.3%
2	1880	18.8%
3	852	8.5%
0	584	5.8%
4	533	5.3%
5	433	4.3%
6	250	2.5%
7	200	2.0%
8	142	1.4%
10	124	1.2%
Other values (26)	469	4.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	584	5.8%
1	4533	45.3%
2	1880	18.8%
3	852	8.5%
4	533	5.3%

Value	Count	Frequency (%)
1050000	2	< 0.1%
866880	2	< 0.1%
72	4	< 0.1%
42	2	< 0.1%
32	4	< 0.1%

ocupacion
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

EMPLEADO	9550
JUBILADOS/PENSIONADO	444
PROFESIONAL INDEPENDIENTE	6

Value	Count	Frequency (%)
EMPLEADO	9550	95.5%
JUBILADOS/PENSIONADO	444	4.4%
PROFESIONAL INDEPENDIENTE	6	0.1%

Length

Max length	25
Mean length	8.543
Min length	8

Value	Count	Frequency (%)
Uppercase_Letter	16	88.9%
Space_Separator	1	5.6%
Other_Punctuation	1	5.6%

Value	Count	Frequency (%)
Latin	16	88.9%
Common	2	11.1%

Value	Count	Frequency (%)
ASCII	18	100.0%

tipcontrato
Categorical

Distinct count	7
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

TÉRMINO INDEFINIDO	7038
TÉRMINO FIJO	1734
OBRA, LABOR O MISIÓN	744
OTROS	446
LIBRE NOMBRAMIENTO O REMOCIÓN	16
Other values (2)	22

Value	Count	Frequency (%)
TÉRMINO INDEFINIDO	7038	70.4%
TÉRMINO FIJO	1734	17.3%
OBRA, LABOR O MISIÓN	744	7.4%
OTROS	446	4.5%
LIBRE NOMBRAMIENTO O REMOCIÓN	16	0.2%
CARRERA ADMINISTRATIVA	14	0.1%
NOMBRAMIENTO PROVISIONAL	8	0.1%

Length

Max length	29
Mean length	16.5566
Min length	5

Value	Count	Frequency (%)
Uppercase_Letter	19	90.5%
Other_Punctuation	1	4.8%
Space_Separator	1	4.8%

Value	Count	Frequency (%)
Latin	19	90.5%
Common	2	9.5%

Value	Count	Frequency (%)
ASCII	19	100.0%

edad
Real number (ℝ_≥0)

Distinct count	52
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	33.6953
Minimum	18
Maximum	69
Zeros	0
Zeros (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	18
5-th percentile	22
Q1	27
median	30
Q3	38
95-th percentile	57
Maximum	69
Range	51
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	10.30236244
Coefficient of variation (CV)	0.305750726
Kurtosis	1.060081067
Mean	33.6953
Median Absolute Deviation (MAD)	8.0212968
Skewness	1.256705791
Sum	336953
Variance	106.1386718

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[18. 19.5 20.5 22.5 24.5 ... 47.5 48.5 51.5 63.5 69. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
27	892	8.9%
26	892	8.9%
28	656	6.6%
29	575	5.8%
30	500	5.0%
31	450	4.5%
25	431	4.3%
32	416	4.2%
33	336	3.4%
34	312	3.1%
Other values (42)	4540	45.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
18	8	0.1%
19	38	0.4%
20	140	1.4%
21	222	2.2%
22	190	1.9%

Value	Count	Frequency (%)
69	22	0.2%
68	20	0.2%
67	20	0.2%
66	18	0.2%
65	26	0.3%

estado_civil
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

SOLTERO	6323
CASADO	1847
OTROS	1562
DIVORCIADO	188
VIUDO	80

Value	Count	Frequency (%)
SOLTERO	6323	63.2%
CASADO	1847	18.5%
OTROS	1562	15.6%
DIVORCIADO	188	1.9%
VIUDO	80	0.8%

Length

Max length	10
Mean length	6.5433
Min length	5

Value	Count	Frequency (%)
Uppercase_Letter	12	100.0%

Value	Count	Frequency (%)
Latin	12	100.0%

Value	Count	Frequency (%)
ASCII	12	100.0%

genero
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

MASCULINO	5505
FEMENINO	4495

Value	Count	Frequency (%)
MASCULINO	5505	55.0%
FEMENINO	4495	45.0%

Length

Max length	9
Mean length	8.5505
Min length	8

Value	Count	Frequency (%)
Uppercase_Letter	11	100.0%

Value	Count	Frequency (%)
Latin	11	100.0%

Value	Count	Frequency (%)
ASCII	11	100.0%

ingresos_totales
Real number (ℝ_≥0)

Distinct count	1599
Unique (%)	16.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.7911684244
Minimum	0.6
Maximum	1.232
Zeros	0
Zeros (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0.6
5-th percentile	0.616
Q1	0.636
median	0.762145
Q3	0.9
95-th percentile	1.1
Maximum	1.232
Range	0.632
Interquartile range (IQR)	0.264

Descriptive statistics

Standard deviation	0.1595499484
Coefficient of variation (CV)	0.2016636958
Kurtosis	-0.4433238676
Mean	0.7911684244
Median Absolute Deviation (MAD)	0.133902923
Skewness	0.6853864304
Sum	7911.684244
Variance	0.02545618604

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0.6 0.608 0.6160255 0.6160275 0.616064 ... 1.1007295 1.155975 1.1954025 1.200108 1.232 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0.616	2078	20.8%
0.8	452	4.5%
0.7	344	3.4%
0.9	296	3.0%
1	294	2.9%
0.75	194	1.9%
0.688	172	1.7%
0.85	164	1.6%
1.2	126	1.3%
1.1	124	1.2%
Other values (1589)	5756	57.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.6	4	< 0.1%
0.616	2078	20.8%
0.616019	2	< 0.1%
0.616024	2	< 0.1%
0.616027	34	0.3%

Value	Count	Frequency (%)
1.232	4	< 0.1%
1.2316	2	< 0.1%
1.2313	2	< 0.1%
1.23	2	< 0.1%
1.229	2	< 0.1%

nivel_academico
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

BACHILLER	3235
TECNÓLOGO	3213
UNIVERSITARIO	2988
OTROS	428
ESPECIALIZACIÓN	136

Value	Count	Frequency (%)
BACHILLER	3235	32.4%
TECNÓLOGO	3213	32.1%
UNIVERSITARIO	2988	29.9%
OTROS	428	4.3%
ESPECIALIZACIÓN	136	1.4%

Length

Max length	15
Mean length	10.1056
Min length	5

Value	Count	Frequency (%)
Uppercase_Letter	18	100.0%

Value	Count	Frequency (%)
Latin	18	100.0%

Value	Count	Frequency (%)
ASCII	17	100.0%

tipo_vivienda
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

FAMILIAR	8284
PROPIA	1122
ALQUILADA	594

Value	Count	Frequency (%)
FAMILIAR	8284	82.8%
PROPIA	1122	11.2%
ALQUILADA	594	5.9%

Length

Max length	9
Mean length	7.835
Min length	6

Value	Count	Frequency (%)
Uppercase_Letter	11	100.0%

Value	Count	Frequency (%)
Latin	11	100.0%

Value	Count	Frequency (%)
ASCII	11	100.0%

calificacion_superfinanciera
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

A	9594
B	122
D	106
E	102
C	76

Value	Count	Frequency (%)
A	9594	95.9%
B	122	1.2%
D	106	1.1%
E	102	1.0%
C	76	0.8%

Length

Max length	1
Mean length	1
Min length	1

Value	Count	Frequency (%)
Uppercase_Letter	5	100.0%

Value	Count	Frequency (%)
Latin	5	100.0%

Value	Count	Frequency (%)
ASCII	5	100.0%

calificacionsistema_financiero
Unsupported

REJECTED
UNSUPPORTED

Missing	92
Missing (%)	0.9%
Memory size	78.2 KiB

moramaxima_12_meses
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct count	91
Unique (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	26.0129
Minimum	0
Maximum	364
Zeros	4222
Zeros (%)	42.2%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	17
Q3	30
95-th percentile	107
Maximum	364
Range	364
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	40.10702172
Coefficient of variation (CV)	1.541812782
Kurtosis	12.11807548
Mean	26.0129
Median Absolute Deviation (MAD)	26.5646022
Skewness	2.96156024
Sum	260129
Variance	1608.573191

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 0. 0.5 7. 14.5 15.5 ... 197.5 200.5 228.5 229.5 364. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	4222	42.2%
17	1366	13.7%
30	549	5.5%
47	375	3.8%
16	324	3.2%
18	300	3.0%
48	286	2.9%
28	230	2.3%
29	190	1.9%
13	164	1.6%
Other values (81)	1994	19.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4222	42.2%
1	36	0.4%
13	164	1.6%
14	42	0.4%
15	136	1.4%

Value	Count	Frequency (%)
364	2	< 0.1%
351	4	< 0.1%
321	4	< 0.1%
320	2	< 0.1%
304	2	< 0.1%

%deuda_actual_sistema_financiero
Real number (ℝ_≥0)

Distinct count	9262
Unique (%)	92.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.7122772989
Minimum	0
Maximum	1
Zeros	5
Zeros (%)	0.1%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.155959325
Q1	0.563666625
median	0.7992201363
Q3	0.9209716541
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.3573050291

Descriptive statistics

Standard deviation	0.2606009835
Coefficient of variation (CV)	0.3658701237
Kurtosis	-0.05900857697
Mean	0.7122772989
Median Absolute Deviation (MAD)	0.2135547169
Skewness	-0.9821633154
Sum	7122.772989
Variance	0.06791287258

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0. 0.00431405 0.02260463 0.07008375 0.1147331 ... 0.98192354 0.99101755 0.99174735 0.99998087 1. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	537	5.4%
0.8987006667	8	0.1%
0.940385	8	0.1%
0.974074	6	0.1%
0.9194576	5	0.1%
0.9607115	5	0.1%
0	5	0.1%
0.8597823333	4	< 0.1%
0.9819233333	4	< 0.1%
0.933133	4	< 0.1%
Other values (9252)	9414	94.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5	0.1%
0.0009995121951	1	< 0.1%
0.001943243243	1	< 0.1%
0.002180869565	1	< 0.1%
0.002213166667	1	< 0.1%

Value	Count	Frequency (%)
1	537	5.4%
0.9999617366	1	< 0.1%
0.9968665	1	< 0.1%
0.995	2	< 0.1%
0.9944965	1	< 0.1%

moramaxima_12_meses_1
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct count	91
Unique (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	26.0129
Minimum	0
Maximum	364
Zeros	4222
Zeros (%)	42.2%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	17
Q3	30
95-th percentile	107
Maximum	364
Range	364
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	40.10702172
Coefficient of variation (CV)	1.541812782
Kurtosis	12.11807548
Mean	26.0129
Median Absolute Deviation (MAD)	26.5646022
Skewness	2.96156024
Sum	260129
Variance	1608.573191

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 0. 0.5 7. 14.5 15.5 ... 197.5 200.5 228.5 229.5 364. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	4222	42.2%
17	1366	13.7%
30	549	5.5%
47	375	3.8%
16	324	3.2%
18	300	3.0%
48	286	2.9%
28	230	2.3%
29	190	1.9%
13	164	1.6%
Other values (81)	1994	19.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4222	42.2%
1	36	0.4%
13	164	1.6%
14	42	0.4%
15	136	1.4%

Value	Count	Frequency (%)
364	2	< 0.1%
351	4	< 0.1%
321	4	< 0.1%
320	2	< 0.1%
304	2	< 0.1%

experiencia_financiera
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

0	6540
1	3460

Frequency Table

Value	Count	Frequency (%)
0	6540	65.4%
1	3460	34.6%

antiguedad_en_el_sistema_financiero
Real number (ℝ_≥0)

ZEROS

Distinct count	138
Unique (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	12.3318
Minimum	0
Maximum	339
Zeros	3368
Zeros (%)	33.7%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	14
95-th percentile	56
Maximum	339
Range	339
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	21.91461462
Coefficient of variation (CV)	1.777081579
Kurtosis	24.20428634
Mean	12.3318
Median Absolute Deviation (MAD)	13.55891092
Skewness	3.833282619
Sum	123318
Variance	480.2503338

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 4.5 6.5 ... 96.5 117. 144. 215. 339. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	3368	33.7%
2	509	5.1%
3	476	4.8%
4	436	4.4%
5	378	3.8%
1	338	3.4%
6	322	3.2%
7	286	2.9%
8	254	2.5%
10	240	2.4%
Other values (128)	3393	33.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3368	33.7%
1	338	3.4%
2	509	5.1%
3	476	4.8%
4	436	4.4%

Value	Count	Frequency (%)
339	2	< 0.1%
217	2	< 0.1%
213	2	< 0.1%
202	2	< 0.1%
200	2	< 0.1%

numero_de_creditos_vigentes
Real number (ℝ_≥0)

ZEROS

Distinct count	6
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1235
Minimum	0
Maximum	5
Zeros	8955
Zeros (%)	89.5%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3973204454
Coefficient of variation (CV)	3.217169599
Kurtosis	23.76677782
Mean	0.1235
Median Absolute Deviation (MAD)	0.2211885
Skewness	4.126298584
Sum	1235
Variance	0.1578635364

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 5. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	8955	89.5%
1	897	9.0%
2	118	1.2%
3	22	0.2%
5	4	< 0.1%
4	4	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8955	89.5%
1	897	9.0%
2	118	1.2%
3	22	0.2%
4	4	< 0.1%

Value	Count	Frequency (%)
5	4	< 0.1%
4	4	< 0.1%
3	22	0.2%
2	118	1.2%
1	897	9.0%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

First rows

	cliente	mora30	mora60	segmento	sector	regcons	fdesem	ingresos	personascargo	gastos	tiempactivano	ocupacion	tipcontrato	edad	estado_civil	genero	ingresos_totales	nivel_academico	tipo_vivienda	calificacion_superfinanciera	calificacionsistema_financiero	moramaxima_12_meses	%deuda_actual_sistema_financiero	moramaxima_12_meses_1	experiencia_financiera	antiguedad_en_el_sistema_financiero	numero_de_creditos_vigentes
0	1	0	0	PY	SERVICIOS	ESPECIAL	2013-11-20	0.000000	0	0.300	0	EMPLEADO	TÉRMINO INDEFINIDO	24	SOLTERO	FEMENINO	0.600	UNIVERSITARIO	FAMILIAR	A	NaN	0	0.636742	0	0	4	0
1	2	1	1	MPY	AGROPECUARIO	OCCIDENTE	2015-12-16	1.500000	3	0.300	4	EMPLEADO	TÉRMINO FIJO	30	OTROS	MASCULINO	0.600	BACHILLER	FAMILIAR	A	666	61	0.934640	61	1	10	0
2	3	0	0	PY	PERSONAS NATURALES	OCCIDENTE	2013-05-08	2.058269	0	0.308	1	EMPLEADO	TÉRMINO INDEFINIDO	37	SOLTERO	MASCULINO	0.616	TECNÓLOGO	FAMILIAR	A	NaN	0	0.117259	0	0	9	0
3	4	0	0	MPY	AGROPECUARIO	CENTRO	2015-11-11	3.500000	1	0.308	6	EMPLEADO	TÉRMINO FIJO	38	SOLTERO	FEMENINO	0.616	BACHILLER	FAMILIAR	A	658	29	1.000000	29	1	8	0
4	5	0	0	MPY	AGROPECUARIO	SUR	2013-12-13	3.655000	0	0.308	3	EMPLEADO	TÉRMINO INDEFINIDO	23	SOLTERO	FEMENINO	0.616	UNIVERSITARIO	FAMILIAR	A	765	17	0.354826	17	0	12	0
5	6	0	0	MPY	AGROPECUARIO	OCCIDENTE	2015-10-15	3.831493	0	0.308	5	EMPLEADO	LIBRE NOMBRAMIENTO O REMOCIÓN	52	OTROS	FEMENINO	0.616	BACHILLER	FAMILIAR	A	697	27	0.866539	27	1	17	1
6	7	0	0	MDO	AGROPECUARIO	SUR	2015-12-10	4.000000	0	0.308	4	EMPLEADO	TÉRMINO INDEFINIDO	29	SOLTERO	FEMENINO	0.616	TECNÓLOGO	ALQUILADA	A	739	0	0.962087	0	0	0	0
7	8	0	0	MDO	PERSONAS NATURALES	ESPECIAL	2012-06-28	5.200000	4	0.308	3	EMPLEADO	TÉRMINO INDEFINIDO	35	CASADO	MASCULINO	0.616	BACHILLER	ALQUILADA	A	848	0	0.344223	0	1	3	0
8	9	0	0	PY	AGROPECUARIO	CENTRO	2013-10-08	7.716000	1	0.308	4	EMPLEADO	TÉRMINO FIJO	36	DIVORCIADO	FEMENINO	0.616	BACHILLER	FAMILIAR	A	.	27	0.331954	27	0	8	0
9	10	1	1	PY	AGROPECUARIO	CENTRO	2013-12-12	7.716000	0	0.308	1	EMPLEADO	TÉRMINO INDEFINIDO	20	SOLTERO	MASCULINO	0.616	BACHILLER	FAMILIAR	A	.	90	0.333311	90	0	0	0

Last rows

	cliente	mora30	mora60	segmento	sector	regcons	fdesem	ingresos	personascargo	gastos	tiempactivano	ocupacion	tipcontrato	edad	estado_civil	genero	ingresos_totales	nivel_academico	tipo_vivienda	calificacion_superfinanciera	calificacionsistema_financiero	moramaxima_12_meses	%deuda_actual_sistema_financiero	moramaxima_12_meses_1	experiencia_financiera	antiguedad_en_el_sistema_financiero	numero_de_creditos_vigentes
9990	9991	0	0	MDO	PERSONAS NATURALES	CENTRO	2015-07-03	1.395000	2	0.308	1	EMPLEADO	TÉRMINO INDEFINIDO	29	OTROS	MASCULINO	1.170051	BACHILLER	FAMILIAR	A	719	0	0.854218	0	0	0	0
9991	9992	0	0	MDO	PERSONAS NATURALES	NORTE	2015-10-05	1.395000	0	0.308	5	EMPLEADO	TÉRMINO INDEFINIDO	42	SOLTERO	MASCULINO	1.190805	UNIVERSITARIO	FAMILIAR	A	697	0	0.946871	0	0	217	0
9992	9993	1	0	MDO	PERSONAS NATURALES	ESPECIAL	2013-05-06	1.395000	2	0.308	15	EMPLEADO	TÉRMINO INDEFINIDO	35	CASADO	FEMENINO	1.202463	TECNÓLOGO	FAMILIAR	A	659	47	0.110401	47	0	2	0
9993	9994	0	0	MDO	PERSONAS NATURALES	ESPECIAL	2013-04-17	1.395000	1	0.308	4	EMPLEADO	TÉRMINO INDEFINIDO	25	OTROS	MASCULINO	1.205505	UNIVERSITARIO	FAMILIAR	A	848	0	0.072081	0	1	16	0
9994	9995	0	0	MDO	PERSONAS NATURALES	ESPECIAL	2015-07-21	1.395000	0	0.308	2	EMPLEADO	TÉRMINO INDEFINIDO	26	OTROS	FEMENINO	1.207553	UNIVERSITARIO	FAMILIAR	A	719	30	0.858635	30	0	2	1
9995	9996	0	0	MDO	PERSONAS NATURALES	OCCIDENTE	2015-08-10	1.395000	1	0.308	1	EMPLEADO	TÉRMINO INDEFINIDO	39	CASADO	FEMENINO	1.222883	TECNÓLOGO	FAMILIAR	A	605	0	0.879227	0	1	1	1
9996	9997	1	1	MDO	PERSONAS NATURALES	OCCIDENTE	2015-04-27	1.395000	2	0.308	1	EMPLEADO	TÉRMINO INDEFINIDO	29	OTROS	MASCULINO	1.170051	BACHILLER	FAMILIAR	A	831	47	0.841957	47	0	16	0
9997	9998	0	0	MDO	PERSONAS NATURALES	CENTRO	2015-06-09	1.395264	0	0.308	5	EMPLEADO	TÉRMINO INDEFINIDO	42	SOLTERO	MASCULINO	1.190805	UNIVERSITARIO	FAMILIAR	A	728	0	0.051393	0	1	2	1
9998	9999	0	0	MDO	PERSONAS NATURALES	CENTRO	2015-09-07	1.395264	2	0.308	15	EMPLEADO	TÉRMINO INDEFINIDO	35	CASADO	FEMENINO	1.202463	TECNÓLOGO	FAMILIAR	A	584	30	0.902128	30	0	1	1
9999	10000	0	0	MDO	PERSONAS NATURALES	CENTRO	2015-08-26	1.395377	1	0.308	4	EMPLEADO	TÉRMINO INDEFINIDO	25	OTROS	MASCULINO	1.205505	UNIVERSITARIO	FAMILIAR	A	697	0	0.923731	0	1	1	1

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Missing values

Sample

First rows

Last rows